<?php require APP_ROOT.'public/top.php';?>
  <?php
	$type_id = pg('type_id');
	$table_name = M('classify_type')->where(array('type_id' => $type_id))->getField('table_name');
	$where=pg('where')!=''?pg('where'):array();
	$where['member_id']=$member_id;
	$data=pg('data');
	$start_date=pg('start_date');
	$end_date=pg('end_date');
	//print_r($data);
	foreach($data as $k=>$v)
	{
		if($v)$where[$k]=$v;
	}
	if($where['start_date'])$where['start_date']=strtotime($where['start_date']);
	if($where['end_date'])$where['end_date']=strtotime($where['end_date']);
	//print_r($where);

	$perpage=20;
	$offset=($p-1)*$perpage;//偏移量
	$list=M($table_name)->where($where)->order('date desc')->limit($offset,$perpage)->select();
	//print_r($where);
	//echo M()->_sql();
	
	$total_num = M($table_name)->count();
	
$list_count=0;
foreach($list as $k2=>$v2){
  $originality_count=0;
  $zxcs=0;
  $djcs=0;
  $djl=0;
  $qccb=0;
  $pjcb=0;
  $countprice=0;
  $jjcgl=0;
  $zhcb=0;
  $cll=0;
  $group_o=0;
  
  $group=M('group')->field('group_id')->where(array('plan_id'=>$v2['plan_id']))->order('date desc')->select();
    foreach($group as $k3=>$v3){
		
	$originality=M('originality')->field('zxcs,djcs,djl,qccb,pjcb,countprice,jjcgl,zhcb,cll')->where(array('group_id'=>$v3['group_id']))->order('date desc')->select();
    foreach($originality as $k=>$v){
      $zxcs+=$v['zxcs'];
      $djcs+=$v['djcs'];
      $djl+=$v['djl'];
      $qccb+=$v['qccb'];
      $pjcb+=$v['pjcb'];
      $countprice+=$v['countprice'];
      $jjcgl+=$v['jjcgl'];
      $zhcb+=$v['zhcb'];
      $cll+=$v['cll'];
    }

//  echo $zhcb.'<br>';
    if(!empty($originality)){
      $group_o+=count($originality);
    }
  }
  if($group_o>0){
    $list_count++;
  }
  $djl=round($djl/($group_o),2).'%';
  //echo $v3['group_id'].':'.$djl.'----'.$group_o.'<br>';
  $qccb=round($qccb/($group_o),2);
  $pjcb=round($pjcb/($group_o),2);
  $jjcgl=round($jjcgl/($group_o),2).'%';
  $zhcb=round($zhcb/($group_o),2);
  $cll=round($cll/($group_o),2).'%';
  
        $zxcs_c+=$zxcs;
        $djcs_c+=$djcs;
        $djl_c+=$djl;
		//echo $v3['group_id'].':'.$djl.'<br>';
        $qccb_c+=$qccb;
        $pjcb_c+=$pjcb;
        $countprice_c+=$countprice;
        $jjcgl_c+=$jjcgl;
        $cll_c+=$cll;
		$zhcb_c+=$zhcb;
  
  $list[$k2]['zxcs']=$zxcs;
  $list[$k2]['djcs']=$djcs;
  $list[$k2]['djl']=$djl;
  $list[$k2]['qccb']=$qccb;
  $list[$k2]['pjcb']=$pjcb;
  $list[$k2]['countprice']=$countprice;
  $list[$k2]['jjcgl']=$jjcgl;
  $list[$k2]['zhcb']=$zhcb;
  $list[$k2]['cll']=$cll;
  if(empty($originality))
  {
    $originality_count++;
  }

if(empty($originality) && $originality_count==0){
      $list[$k2]['zxcs']='--';
      $list[$k2]['djcs']='--';
      $list[$k2]['djl']='--';
      $list[$k2]['qccb']='--'; 
      $list[$k2]['pjcb']='--';
      $list[$k2]['countprice']='--';
      $list[$k2]['jjcgl']='--';
      $list[$k2]['zhcb']='--';
      $list[$k2]['cll']='--';
  }

}
//echo $list_count.'***';
//echo $djl_c;
  $djl_c=round($djl_c/($list_count),2).'%';
  $qccb_c=round($qccb_c/($list_count),2);
  $pjcb_c=round($pjcb_c/($list_count),2);
  $jjcgl_c=round($jjcgl_c/($list_count),2).'%';
  $zhcb_c=round($zhcb_c/($list_count),2);
  $cll_c=round($cll_c/($list_count),2).'%';

?>

<div id="g-body" class="g-bd f-cb" style="background:none">
  <div class="g-mn">
    <div id="g-content" class="g-ct" style="margin-left:0">
	<?php require APP_ROOT.'public/right.php';?>
      <div class="fixed-wrapper js-header-parent" style="height: auto;">
        <table id="lists-header" class="c-table1 list e-table-sorter" width="100%" style="position: static; width: 100%; top: 0px; left: 20px; z-index: 0;">
          <tbody>
            
            
          </tbody>
        </table>
      </div>
      <table id="lists" class="c-table1 list e-table-sorter" width="100%" style="">
      <thead>
      <tr>
              <th width="49"><input id="check-all" type="checkbox" autocomplete="off">
                全选</th>
              <th width="199" sorttype="createtime"><span class="e-table-sorter-header" sorttype="createtime">推广计划</span></th>
              <th width="129" custom_col="status">投放状态&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="推广计划包括以下10种投放状态:<br/>1.有效<br/>2.暂停<br/>3.非投放日期<br/>4.非投放时段<br/>5.推广计划预算不足<br/>6.APP更新中<br/>7.渠道包版本过低<br/>8.渠道包被删除<br/>9.官网包被删除"></i></th>
              <th custom_col="ad_model" style="display:none;" width="21">广告模式</th>
              <th custom_col="ad_type" width="82">推广目的</th>
              <th custom_col="os" style="display:none;" width="46">操作系统</th>
              <th custom_col="budget" sorttype="budget" width="82"><span class="e-table-sorter-header" sorttype="budget">预算(元/天)</span></th>
              <th custom_col="equalbudgetflag" style="display:none;" width="23">预算消耗方式</th>
              <th custom_col="delivery_time" style="display:none;" width="72">投放时段</th>
              <th custom_col="delivery_date" style="display:none;" width="66">开始日期</th>
              <th custom_col="delivery_date" style="display:none;" width="11">结束时间</th>
              <th custom_col="views" sorttype="views" width="82"><span class="e-table-sorter-header" sorttype="views">展现次数</span></th>
              <th custom_col="clicks" sorttype="clicks" width="82"><span class="e-table-sorter-header" sorttype="clicks">点击次数</span></th>
              <th custom_col="click_percent" sorttype="click_percent" width="83"><span class="e-table-sorter-header" sorttype="click_percent">点击率</span></th>
              <th custom_col="thousand_views" sorttype="thousand_views" width="83"><span class="e-table-sorter-header" sorttype="thousand_views">千次展现成本</span></th>
              <th custom_col="click_cost" sorttype="click_cost" width="83"><span class="e-table-sorter-header" sorttype="click_cost">平均点击成本</span></th>
              <th custom_col="total_cost" sorttype="total_cost" width="83"><span class="e-table-sorter-header" sorttype="total_cost">总费用</span></th>
              <th custom_col="bid_rate" sorttype="bid_rate" width="83"><span class="e-table-sorter-header" sorttype="bid_rate">竞价成功率</span></th>
              <th custom_col="converts" style="display:none;" sorttype="converts" width="9"><span class="e-table-sorter-header" sorttype="converts">转化数&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="该计划下所有推广组转化数的总和"></i></span></th>
              <th custom_col="convert_rate" style="display:none;" sorttype="convert_rate" width="9"><span class="e-table-sorter-header" sorttype="convert_rate">转化率&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="转化数/点击数"></i></span></th>
              <th custom_col="convert_cost" sorttype="convert_cost" width="83"><span class="e-table-sorter-header" sorttype="convert_cost">转化成本&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="总费用/转化数，由于总费用可能包含该计划下非oCPC推广组的费用，故显示的转化成本可能偏高"></i></span></th>
              <th custom_col="ocpc_down_active" style="display:none;" sorttype="ocpc_down_active" width="4"><span class="e-table-sorter-header" sorttype="ocpc_down_active">激活数&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="该账户下所有推广组激活数的总和"></i></span></th>
              <th custom_col="active_rate" style="display:none;" sorttype="active_rate" width="4"><span class="e-table-sorter-header" sorttype="active_rate">激活率&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="激活数/点击数"></i></span></th>
              <th custom_col="active_cost" style="display:none;" sorttype="active_cost" width="4"><span class="e-table-sorter-header" sorttype="active_cost">激活成本&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="总费用/激活数，由于总费用可能包含该账户下非oCPC推广组的费用，故显示的激活成本可能偏高"></i></span></th>
              <th custom_col="ocpc_down_reg" style="display:none;" sorttype="ocpc_down_reg" width="4"><span class="e-table-sorter-header" sorttype="ocpc_down_reg">注册数&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="该账户下所有推广组注册数的总和"></i></span></th>
              <th custom_col="reg_rate" style="display:none;" sorttype="reg_rate" width="4"><span class="e-table-sorter-header" sorttype="reg_rate">注册率&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="注册数/激活数"></i></span></th>
              <th custom_col="reg_cost" style="display:none;" sorttype="reg_cost" width="4"><span class="e-table-sorter-header" sorttype="reg_cost">注册成本&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="总费用/注册数，由于总费用可能包含该账户下非oCPC推广组的费用，故显示的注册成本可能偏高"></i></span></th>
              <th custom_col="ocpc_down_retention" style="display:none;" sorttype="ocpc_down_retention" width="4"><span class="e-table-sorter-header" sorttype="ocpc_down_retention">次留数&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="该账户下所有推广组次留数的总和"></i></span></th>
              <th custom_col="retention_rate" sorttype="retention_rate" width="83"><span class="e-table-sorter-header" sorttype="retention_rate">次留率&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="当日次留数/前一日的激活数"></i></span></th>
              <th custom_col="retention_cost" style="display:none;" sorttype="retention_cost" width="4"><span class="e-table-sorter-header" sorttype="retention_cost">次留成本&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="前一日的总费用/当日次留数，由于总费用可能包含该账户下非oCPC推广组的费用，故显示的次留成本可能偏高"></i></span></th>
              <th custom_col="ocpc_down_pay" style="display:none;" sorttype="ocpc_down_pay" width="4"><span class="e-table-sorter-header" sorttype="ocpc_down_pay">付费数&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="该账户下所有推广组付费数的总和"></i></span></th>
              <th custom_col="pay_rate" style="display:none;" sorttype="pay_rate" width="4"><span class="e-table-sorter-header" sorttype="pay_rate">付费率&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="付费数/激活数"></i></span></th>
              <th custom_col="pay_cost" style="display:none;" sorttype="pay_cost" width="4"><span class="e-table-sorter-header" sorttype="pay_cost">付费成本&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="总费用/付费数，由于总费用可能包含该账户下非oCPC推广组的费用，故显示的付费成本可能偏高"></i></span></th>
              <th custom_col="ocpc_down_quality" style="display:none;" sorttype="ocpc_down_quality" width="4"><span class="e-table-sorter-header" sorttype="ocpc_down_quality">质量度&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="该账户下所有推广组质量度数的总和"></i></span></th>
              <th custom_col="quality_rate" style="display:none;" sorttype="quality_rate" width="4"><span class="e-table-sorter-header" sorttype="quality_rate">质量度率&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="质量度数/激活数"></i></span></th>
              <th custom_col="quality_cost" style="display:none;" sorttype="quality_cost" width="4"><span class="e-table-sorter-header" sorttype="quality_cost">质量度成本&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="总费用/质量度数，由于总费用可能包含该账户下非oCPC推广组的费用，故显示的质量度成本可能偏高"></i></span></th>
              <th custom_col="call_num" style="display:none;" sorttype="call_num" width="6"><span class="e-table-sorter-header" sorttype="call_num">电话拨打量&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="所筛选日期的总电话拨打数"></i></span></th>
              <th custom_col="form_commit_num" style="display:none;" sorttype="form_commit_num" width="6"><span class="e-table-sorter-header" sorttype="form_commit_num">表单提交量&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="所筛选日期的总表单提交数"></i></span></th>
              <th custom_col="advice_num" style="display:none;" sorttype="advice_num" width="6"><span class="e-table-sorter-header" sorttype="advice_num">咨询量&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="所筛选日期的总咨询窗口调起数"></i></span></th>
              <th custom_col="clue_num" style="display:none;" sorttype="clue_num" width="6"><span class="e-table-sorter-header" sorttype="clue_num">线索量&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="所筛选日期的电话拨打数、表单提交数、咨询数的总和"></i></span></th>
              <th custom_col="clue_rate" style="display:none;" sorttype="clue_rate" width="6"><span class="e-table-sorter-header" sorttype="clue_rate">线索率&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="线索量/点击数"></i></span></th>
              <th custom_col="clue_cost" style="display:none;" sorttype="clue_cost" width="6"><span class="e-table-sorter-header" sorttype="clue_cost">线索成本&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="总费用/线索量"></i></span></th>
              <th custom_col="download_num" style="display:none;" sorttype="download_num" width="6"><span class="e-table-sorter-header" sorttype="download_num">网页下载量&nbsp;<i class="f-efonts f-fs14 j-tips" data-tips="所筛选日期的总网页下载量"></i></span></th>
              <th width="99">操作</th>
            </tr>
      </thead>
        <tbody>
          <tr class="total_row">
            <td width="50" class="j-guide-6"></td>
            <td width="200"></td>
            <td width="120" custom_col="status" class="f-tal" style="padding:0 5px;text-align:center">
            </td>
            <td custom_col="ad_model" style="display: none;">RTB</td>
            <td custom_col="ad_type">移动网站推广</td>
            <td custom_col="os" style="display: none;">Android </td>
            <td custom_col="budget"><a data-pid="41220203" data-amt="0" class="btn-plan-budget" href="javascript:void(0)">--</a></td>
            <td custom_col="equalbudgetflag" style="display: none;">快速</td>
            <td custom_col="delivery_time" style="display: none;"><span data-pid="41220203" class="btn-time"><span id="advert-period-bar"><span id="advert-period-bar-tip">全部时段</span>&nbsp;&nbsp;<a id="advert-period-bar-btn" title="修改" class="f-efonts f-gray f-fs18" href="javascript:void(0)"></a></span></span>
              </td>
            <td custom_col="delivery_date" style="display: none;">2020-07-23</td>
            <td custom_col="delivery_date" style="display: none;">无</td>
            <td custom_col="views" class="f-tar"><?php echo (int)$zxcs_c;?></td>
            <td custom_col="clicks" class="f-tar"><?php echo (int)$djcs_c;?></td>
            <td custom_col="click_percent" class="f-tar"><?php echo $djl_c;?></td>
            <td custom_col="thousand_views" class="f-tar"><?php echo $qccb_c;?></td>
            <td custom_col="click_cost" class="f-tar"><?php echo $pjcb_c;?></td>
            <td custom_col="total_cost" class="f-tar"><?php echo $countprice_c;?></td>
            <td custom_col="bid_rate" class="f-tar"><?php echo $jjcgl_c;?></td>
            <td custom_col="converts" style="display: none;" class="f-tar">--</td>
            <td custom_col="convert_rate" style="display: none;" class="f-tar">--</td>
            <td custom_col="convert_cost" class="f-tar"><?php echo $zhcb_c;?></td>
            <td custom_col="ocpc_down_active" style="display: none;" class="f-tar">--</td>
            <td custom_col="active_rate" style="display: none;" class="f-tar">--</td>
            <td custom_col="active_cost" style="display: none;" class="f-tar">--</td>
            <td custom_col="ocpc_down_reg" style="display: none;" class="f-tar">--</td>
            <td custom_col="reg_rate" style="display: none;" class="f-tar">--</td>
            <td custom_col="reg_cost" style="display: none;" class="f-tar">--</td>
            <td custom_col="ocpc_down_retention" style="display: none;" class="f-tar">--</td>
            <td custom_col="retention_rate" class="f-tar"><?php echo $cll_c;?></td>
            <td custom_col="retention_cost" style="display: none;" class="f-tar">--</td>
            <td custom_col="ocpc_down_pay" style="display: none;" class="f-tar">--</td>
            <td custom_col="pay_rate" style="display: none;" class="f-tar">--</td>
            <td custom_col="pay_cost" style="display: none;" class="f-tar">--</td>
            <td custom_col="ocpc_down_quality" style="display: none;" class="f-tar">--</td>
            <td custom_col="quality_rate" style="display: none;" class="f-tar">--</td>
            <td custom_col="quality_cost" style="display: none;" class="f-tar">--</td>
            <td custom_col="call_num" style="display: none;" class="f-tar">0</td>
            <td custom_col="form_commit_num" style="display: none;" class="f-tar">0</td>
            <td custom_col="advice_num" style="display: none;" class="f-tar">0</td>
            <td custom_col="clue_num" style="display: none;" class="f-tar">0</td>
            <td custom_col="clue_rate" style="display: none;" class="f-tar">0</td>
            <td custom_col="clue_cost" style="display: none;" class="f-tar">0</td>
            <td custom_col="download_num" style="display: none;" class="f-tar">0</td>
            <td width="100"></td>
          </tr>
          
          <?php
				foreach($list as $k=>$v){
				?>
          <tr>
            <td width="50" class="j-guide-6"><input type="checkbox" name="check-id" data-status="0" value="41220203" data-name="213" data-equalbudgetflag="1"></td>
            <td width="200"><a href="index.php?m=group&a=index&type_id=64&plan_id=<?php echo $v['plan_id'];?>"><?php echo $v['plan_name'];?></a></td>
            <td width="120" custom_col="status" class="f-tal" style="padding:0 5px;text-align:center">
           <?php if($v['state']==1){?>
            <a class="btn-switch f-orange f-fr" onClick="ajax_list('index.php?m=cms&a=ajax_save&content_id=<?php echo $v['plan_id'];?>&type_id=63&data[state]=2','')"><i class="f-efonts"></i></a>
            <?php }else if($v['state']==2){?>
            <a class="btn-switch f-green f-fr" onClick="ajax_list('index.php?m=cms&a=ajax_save&content_id=<?php echo $v['plan_id'];?>&type_id=63&data[state]=1','')"><i class="f-efonts"></i></a> <?php }?>
			<?php $state= M('input')->where(array('input_pid'=>635,'input_value'=>$v['state']))->getfield('input_name');?>
			<?php if($v['state']==1){?><span class="g-status-green"><?php echo $state;?></span><?php }else if($v['state']==2){?>
            <span class="g-status-orange"><?php echo $state;?></span> <?php }?>
            </td>
            <td custom_col="ad_model" style="display: none;">RTB</td>
            <td custom_col="ad_type">移动网站推广</td>
            <td custom_col="os" style="display: none;">Android </td>
            <td custom_col="budget"><a data-pid="41220203" data-amt="0" class="btn-plan-budget" href="javascript:void(0)"><?php if($v['isys']==1){?>不限<?php  }else{ echo $v['ys']; }?></a></td>
            <td custom_col="equalbudgetflag" style="display: none;">快速</td>
            <td custom_col="delivery_time" style="display: none;"><span data-pid="41220203" class="btn-time"><span id="advert-period-bar"><span id="advert-period-bar-tip">全部时段</span>&nbsp;&nbsp;<a id="advert-period-bar-btn" title="修改" class="f-efonts f-gray f-fs18" href="javascript:void(0)"></a></span></span>
              </td>
            <td custom_col="delivery_date" style="display: none;">2020-07-23</td>
            <td custom_col="delivery_date" style="display: none;">无</td>
            <td custom_col="views" class="f-tar"><?php echo (int)$v['zxcs'];?></td>
            <td custom_col="clicks" class="f-tar"><?php echo (int)$v['djcs'];?></td>
            <td custom_col="click_percent" class="f-tar"><?php echo $v['djl'];?></td>
            <td custom_col="thousand_views" class="f-tar"><?php echo $v['qccb'];?></td>
            <td custom_col="click_cost" class="f-tar"><?php echo $v['pjcb'];?></td>
            <td custom_col="total_cost" class="f-tar"><?php echo $v['countprice'];?></td>
            <td custom_col="bid_rate" class="f-tar"><?php echo $v['jjcgl'];?></td>
            <td custom_col="converts" style="display: none;" class="f-tar">--</td>
            <td custom_col="convert_rate" style="display: none;" class="f-tar">--</td>
            <td custom_col="convert_cost" class="f-tar"><?php echo $v['zhcb'];?></td>
            <td custom_col="ocpc_down_active" style="display: none;" class="f-tar">--</td>
            <td custom_col="active_rate" style="display: none;" class="f-tar">--</td>
            <td custom_col="active_cost" style="display: none;" class="f-tar">--</td>
            <td custom_col="ocpc_down_reg" style="display: none;" class="f-tar">--</td>
            <td custom_col="reg_rate" style="display: none;" class="f-tar">--</td>
            <td custom_col="reg_cost" style="display: none;" class="f-tar">--</td>
            <td custom_col="ocpc_down_retention" style="display: none;" class="f-tar">--</td>
            <td custom_col="retention_rate" class="f-tar"><?php echo $v['cll'];?></td>
            <td custom_col="retention_cost" style="display: none;" class="f-tar">--</td>
            <td custom_col="ocpc_down_pay" style="display: none;" class="f-tar">--</td>
            <td custom_col="pay_rate" style="display: none;" class="f-tar">--</td>
            <td custom_col="pay_cost" style="display: none;" class="f-tar">--</td>
            <td custom_col="ocpc_down_quality" style="display: none;" class="f-tar">--</td>
            <td custom_col="quality_rate" style="display: none;" class="f-tar">--</td>
            <td custom_col="quality_cost" style="display: none;" class="f-tar">--</td>
            <td custom_col="call_num" style="display: none;" class="f-tar">0</td>
            <td custom_col="form_commit_num" style="display: none;" class="f-tar">0</td>
            <td custom_col="advice_num" style="display: none;" class="f-tar">0</td>
            <td custom_col="clue_num" style="display: none;" class="f-tar">0</td>
            <td custom_col="clue_rate" style="display: none;" class="f-tar">0</td>
            <td custom_col="clue_cost" style="display: none;" class="f-tar">0</td>
            <td custom_col="download_num" style="display: none;" class="f-tar">0</td>
            <td width="100"><a href="index.php?m=plan&a=edit&type_id=<?php echo $type_id;?>&table_name=<?php echo $table_name;?>&content_id=<?php echo $v[$table_name.'_id'];?>" title="编辑计划"><i class="f-efonts f-fs18 f-blue f-vam"></i></a>&nbsp;&nbsp;&nbsp; <a class="btn-del" href="javascript:void(0)" title="删除计划" onclick="if(confirm('确定删除吗!')){ajax_list('index.php?m=cms&a=del_save&type_id=63&content_id=<?php echo $v['plan_id'];?>','')}"><i class="f-efonts f-fs16 f-blue"></i></a>&nbsp;&nbsp;&nbsp; <a href="index.php?m=group&a=add&type_id=64&plan_id=<?php echo $v['plan_id'];?>" title="添加组"><i class="f-efonts f-fs16 f-blue"></i></a></td>
          </tr>
          <?php }?>
          
          
        </tbody>
      </table>
<?php require APP_ROOT.'public/page.php';?>

    </div>
  </div>
</div>
<script type="text/javascript">
</script>
<?php require APP_ROOT.'public/bottom.php';?>
